<template>
  <view>
    <view class="uni-header">
      <view class="uni-group">
        <view class="uni-title"></view>
        <view class="uni-sub-title"></view>
      </view>
      <view class="uni-group">
        <input class="uni-search" type="text" v-model="query" @confirm="search" placeholder="请输入搜索内容" />
        <button class="uni-button" type="default" size="mini" @click="search">搜索</button>
        <button class="uni-button" type="default" size="mini" @click="navigateTo('./add')"
          v-if="!$hasRole('admin')">新增</button>
        <button class="uni-button" type="default" size="mini" :disabled="!selectedIndexs.length"
          @click="delTable">批量删除</button>
        <download-excel class="hide-on-phone" :fields="exportExcel.fields" :data="exportExcelData"
          :type="exportExcel.type" :name="exportExcel.filename">
          <button class="uni-button" type="primary" size="mini">导出 Excel</button>
        </download-excel>
      </view>
    </view>
    <view class="uni-container">
      <unicloud-db ref="udb" :collection="collectionList"
        field="user_id,company_name,business_license,legal_person_idcard,auth_status,submit_time,audit_time,audit_remark,contact_info,extra_files"
        :where="where" page-data="replace" :orderby="orderby" :getcount="true" :page-size="options.pageSize"
        :page-current="options.pageCurrent" v-slot:default="{ data, pagination, loading, error, options }"
        :options="options" loadtime="manual" @load="onqueryload">
        <uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe type="selection"
          @selection-change="selectionChange">
          <uni-tr>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'user_id')" sortable
              @sort-change="sortChange($event, 'user_id')">user_id</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'company_name')" sortable
              @sort-change="sortChange($event, 'company_name')">企业名称</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'business_license')">营业执照</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'legal_person_idcard')">法人身份证</uni-th>
            <uni-th align="center" filter-type="select" :filter-data="options.filterData.auth_status_localdata"
              @filter-change="filterChange($event, 'auth_status')">认证状态</uni-th>
            <uni-th align="center" filter-type="timestamp" @filter-change="filterChange($event, 'submit_time')" sortable
              @sort-change="sortChange($event, 'submit_time')">提交时间</uni-th>
            <uni-th align="center" filter-type="timestamp" @filter-change="filterChange($event, 'audit_time')" sortable
              @sort-change="sortChange($event, 'audit_time')">审核时间</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'audit_remark')" sortable
              @sort-change="sortChange($event, 'audit_remark')">审核备注</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'contact_info')">联系方式</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'extra_files')">补充材料</uni-th>
            <uni-th align="center">操作</uni-th>
          </uni-tr>
          <uni-tr v-for="(item, index) in data" :key="index">
            <uni-td align="center">{{ item.user_id }}</uni-td>
            <uni-td align="center">{{ item.company_name }}</uni-td>
            <uni-td align="center">
              <uni-file-picker v-if="item.business_license && item.business_license.fileType == 'image'"
                :value="item.business_license" :file-mediatype="item.business_license && item.business_license.fileType"
                return-type="object" :imageStyles="imageStyles" readonly></uni-file-picker>
              <uni-link v-else :href="item.business_license && item.business_license.url"
                :text="item.business_license && item.business_license.url"></uni-link>
            </uni-td>
            <uni-td align="center">{{ item.legal_person_idcard }}</uni-td>
            <uni-td align="center">{{ options.auth_status_valuetotext[item.auth_status] }}</uni-td>
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.submit_time"></uni-dateformat>
            </uni-td>
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.audit_time"></uni-dateformat>
            </uni-td>
            <uni-td align="center">{{ item.audit_remark }}</uni-td>
            <uni-td align="center">{{ item.contact_info }}</uni-td>
            <uni-td align="center">{{ item.extra_files }}</uni-td>
            <uni-td align="center">
              <view class="uni-group">
                <button @click="navigateTo('./edit?id=' + item._id, false)" class="uni-button" size="mini"
                  type="primary">修改</button>
                <button @click="confirmDelete(item._id)" class="uni-button" size="mini" type="warn">删除</button>
              </view>
            </uni-td>
          </uni-tr>
        </uni-table>
        <view class="uni-pagination-box">
          <uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current" :total="pagination.count"
            @change="onPageChanged" />
        </view>
      </unicloud-db>
    </view>
  </view>
</template>

<script>
import { enumConverter, filterToWhere } from '../../js_sdk/validator/merchant-auth.js';
import { READ_PERMISSION } from '../../utils/constants.js'

const db = uniCloud.database()
// 表查询配置
const dbOrderBy = 'submit_time desc' // 排序字段
const dbSearchFields = [] // 模糊搜索字段，支持模糊搜索的字段列表。联表查询格式: 主表字段名.副表字段名，例如用户表关联角色表 role.role_name
// 分页配置
const pageSize = 20
const pageCurrent = 1

const orderByMapping = {
  "ascending": "asc",
  "descending": "desc"
}

export default {
  data() {
    return {
      collectionList: "merchant-auth",
      query: '',
      where: '',
      orderby: dbOrderBy,
      orderByFieldName: "",
      selectedIndexs: [],
      options: {
        pageSize,
        pageCurrent,
        filterData: {
          "auth_status_localdata": [
            {
              "value": "pending",
              "text": "审核中"
            },
            {
              "value": "approved",
              "text": "通过"
            },
            {
              "value": "rejected",
              "text": "未通过"
            }
          ]
        },
        ...enumConverter
      },
      imageStyles: {
        width: 64,
        height: 64
      },
      exportExcel: {
        "filename": "merchant-auth.xls",
        "type": "xls",
        "fields": {
          "user_id": "user_id",
          "企业名称": "company_name",
          "营业执照": "business_license",
          "法人身份证": "legal_person_idcard",
          "认证状态": "auth_status",
          "提交时间": "submit_time",
          "审核时间": "audit_time",
          "审核备注": "audit_remark",
          "联系方式": "contact_info",
          "补充材料": "extra_files"
        }
      },
      exportExcelData: []
    }
  },
  onLoad() {
    this._filter = {}
  },
  onReady() {
    this.$refs.udb.loadData()
  },
  methods: {
    onqueryload(data) {
      this.exportExcelData = data
    },
    getWhere() {
      const query = this.query.trim()
      if (!query) {
        return ''
      }
      const queryRe = new RegExp(query, 'i')
      return dbSearchFields.map(name => queryRe + '.test(' + name + ')').join(' || ')
    },
    search() {
      const newWhere = this.getWhere()
      this.where = newWhere
      this.$nextTick(() => {
        this.loadData()
      })
    },
    loadData(clear = true) {
      this.$refs.udb.loadData({
        clear
      })
    },
    onPageChanged(e) {
      this.selectedIndexs.length = 0
      this.$refs.table.clearSelection()
      this.$refs.udb.loadData({
        current: e.current
      })
    },
    navigateTo(url, clear) {
      // clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
      uni.navigateTo({
        url,
        events: {
          refreshData: () => {
            this.loadData(clear)
          }
        }
      })
    },
    // 多选处理
    selectedItems() {
      var dataList = this.$refs.udb.dataList
      return this.selectedIndexs.map(i => dataList[i]._id)
    },
    // 批量删除
    delTable() {
      this.$refs.udb.remove(this.selectedItems(), {
        success: (res) => {
          this.$refs.table.clearSelection()
        }
      })
    },
    // 多选
    selectionChange(e) {
      this.selectedIndexs = e.detail.index
    },
    confirmDelete(id) {
      this.$refs.udb.remove(id, {
        success: (res) => {
          this.$refs.table.clearSelection()
          uni.showToast({
            title: '删除成功'
          })
        },
        fail: (err) => {
          uni.showToast({
            title: '删除失败',
            icon: 'error'
          })
          console.error(err)
        }
      })
    },
    sortChange(e, name) {
      this.orderByFieldName = name;
      if (e.order) {
        this.orderby = name + ' ' + orderByMapping[e.order]
      } else {
        this.orderby = ''
      }
      this.$refs.table.clearSelection()
      this.$nextTick(() => {
        this.$refs.udb.loadData()
      })
    },
    filterChange(e, name) {
      this._filter[name] = {
        type: e.filterType,
        value: e.filter
      }
      let newWhere = filterToWhere(this._filter, db.command)
      if (Object.keys(newWhere).length) {
        this.where = newWhere
      } else {
        this.where = ''
      }
      this.$nextTick(() => {
        this.$refs.udb.loadData()
      })
    }
  }
}
</script>

<style></style>
